Named Ranges and Lookup |
Working with Named Ranges |
|
Vlookup and Hlookup Functions |
Data Management |
Importing and Exporting Files |
|
Custom and Conditional Formats |
|
Validating Data |
|
XML and Web Queries |
Group Editing |
Sharing and Protecting Files |
|
Using Comments |
|
Tracking Changes |
Auditing, Scenarios and Reporting |
Auditing Tools |
|
Using the Scenario Manager |
|
Using Custom Views |
|
Working with Report Manager |
Database and Analysis Tools |
Working with Databases |
|
Filtering Data |
|
Sorting and Subtotalling |
|
Goal Seeker and Solver |
PivotTables |
Working with PivotTables |
|
Using PivotCharts |
|
PivotTables on the Web |